🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-23 🟢

🔹 Automate Cold Email Personalisation from Google Sheets
👤 Client: 🇩🇪 Germany Member since 2016-12-26
💰 Price: $5.00-$13.00 Hourly
🚩 Problem: Need a system to automate cold email personalisation by scraping company websites or performing web searches for factual, concise sentences.
📦 Existing: [Not specified]

Specifications:

[Target] - Extract data from Google Sheets and generate personalised emails based on scraped information or web search results.
[Method] - Use Python with libraries like Selenium for web scraping and BeautifulSoup for parsing HTML. Integrate with Google Sheets API for data access.
[UI/UX] - Design a simple UI in Google Sheets that allows users to input company names and expected outcomes, triggering the script with one click.
[Stack] - Python, Selenium, BeautifulSoup, Google Sheets API
[Security] - Ensure data privacy by not storing sensitive information. Use secure authentication methods for accessing APIs.
[Format] - JSON or CSV output for email content.

Workflow:

1. Connect to Google Sheets and extract company names and other relevant details.
2. For each company, visit the website if available; otherwise, perform a web search.
3. Extract factual information and generate a personalised sentence (max 25 words).
4. Store or output the generated sentences in a structured format for email use.